There is a real need for Visual Basic programs accessing databases to allow users to run 'ad-hoc' queries. No such mechanism now exists to my knowledge outside of the bad query procedures section of Visdata. I moved and modified the query section of VISNEWDB into a new program called MQUERY. MQUERY will allow programmers to take MQUERY code, all or in part, and splice it into their program(s). Passing the selected database name and path and an ini file name and eliminating the splash form is all that is necessary. MQUERY as of now is for ACCESS database's only. I also have a version, MSQLQRY for Sql-Server databases. Both have been tested and are in use in enterprise wide applications and allow users to store, load and run private and public queries generated by names they choose. To access other Databases, modify the mopendb.frm in MSQLQRY. MQUERY will run as a standalone program with query storage if you use the NWIND.MDB database provided with MS Access, and the Storeqry.ini file copied to your Windows directory.
